Lecture-1: Introduction to Databases

Updated: August 8, 2025

Lecture-2: Introduction to Database, Database users, characteristics and advantages of the database, Database systems, Concepts and architecture-Data models

Updated: August 12, 2025

Lecture-3: Schemas, Instances & States, Three-Schema Architecture, and Data Independence.

Updated: August 18, 2025

Lecture-4: DBMS Languages & Interfaces - DDL, DML, DCL, TCL, High-Level vs Low-Level Languages, DBMS Interfaces, System Utilities, and Component Modules

Updated: August 22, 2025

Lecture-5: Integrity Constraints in DBMS

Understanding and implementing domain, key, entity, and referential integrity constraints in database systems

Updated: September 4, 2025

Lecture-6: EER Diagram & Reduction to Tables

Understanding Extended Entity-Relationship (EER) modeling, specialization, generalization, and converting EER diagrams to relational tables

Updated: September 7, 2025

Lecture-7: Relational Algebra & Relational Calculus

Comprehensive coverage of relational algebra operations and relational calculus for database querying, including set operations, joins, and division

Updated: September 8, 2025

Lecture-8: Database Anomalies and Dependencies

Understanding and resolving database anomalies through functional, multivalued, and join dependencies, and their role in database normalization

Updated: September 9, 2025

Lecture-9: Normal Forms & Limitations of Relational Data Model

Understand Normalization and Limitations of Relational Data Model

Updated: September 9, 2025

Lecture-10: Introduction to Transactions

Understanding transaction concepts, ACID properties, transaction states, and concurrency control in database systems

Updated: September 26, 2025

Lecture-11: Concurrency Control Protocols & Deadlocks

Exploring concurrency control mechanisms, two-phase locking, timestamp ordering, and deadlock handling in database systems

Updated: October 1, 2025

Lecture-12: Query Optimization

Understanding query processing, cost-based optimization, and query execution plans in database systems

Updated: October 3, 2025

Lecture-13: File Organization and Indexing

Understanding file organization techniques (heap, sequential, hash), indexing concepts, primary indexes, and performance analysis with practical calculations

Updated: October 14, 2025

Lecture-14: Clustering and Secondary Indexing

Deep dive into clustering indexes, secondary indexes, dense vs sparse indexing, with practical examples and performance calculations

Updated: October 16, 2025

Lecture-15: Tree-Based Indexing

Deep dive into B-Tree & B+ Tree

Updated: October 31, 2025

Lecture-16: Hash-Based Indexing

Understanding static, extendible, and linear hashing techniques with practical examples and performance analysis

Updated: November 14, 2025

Lecture-23: Introduction to Distributed Databases, Key Characteristics, Need for Distributed DBMS & Architecture

Lecture-24: Data Fragmentation in Distributed Databases

Lecture-25: Query Processing in Distributed Databases: Query Decomposition, Data Localization,
Distributed Query Processing,
Transaction Management & Concurrency Control

Lecture-26: NoSQL Databases: Overview & Comparison(Overview, Types, Use Cases & Comparison with RDBMS)

Lecture-17: Introduction to Data Warehousing

Understanding the fundamentals of data warehousing, OLTP vs OLAP, data warehouse architectures, and dimensional modeling concepts

Updated: November 18, 2025

Lecture-18: Dimensional Database Design

Exploring dimensional modeling concepts, star schema, snowflake schema, fact constellation, and OLAP cube operations

Updated: November 18, 2025

Lecture-19: ETL Processing & Aggregates

Understanding ETL (Extract, Transform, Load) processes, Slowly Changing Dimensions (SCD), and implementing aggregation strategies for performance optimization

Updated: November 18, 2025

Lecture-20: Star Schema & Snowflake Schema

Understanding dimensional modeling concepts, star and snowflake schemas, and their applications in data warehousing

Updated: November 20, 2025

Lecture-21: Knowledge Discovery in Databases

Understanding knowledge discovery in databases, data mining concepts, and their applications in database systems

Updated: November 21, 2025

Lecture-22: Real-World Database Applications

Exploring real-world database applications, case studies, and project implementation strategies in database systems

Updated: November 25, 2025

Lab 1: University Database ER Diagram

Design and Implementation of University Database System - ER diagram specifications, SQL schema, and database model

Updated: August 17, 2025

Lab 2: Company Database ER Diagram

Design Assignment - Create ER diagram for company database with employees, departments, projects, and relationships

Updated: August 17, 2025

Lab 3: DDL and DML Commands with Key Constraints

Hands-on practice with SQL DDL and DML commands, implementing database constraints (Primary Key, Foreign Key, UNIQUE, CHECK), and testing referential integrity

Updated: September 1, 2025

Lab 4: SQL Constraints Implementation

Understanding and applying SQL constraints including Primary Key, Foreign Key, and other integrity constraints with practical exercises

Updated: September 7, 2025

Lab 5: To understand and use SQL Sub-Query

Objective: To understand the use of SQL subquery and implement various subquery operations on relational database tables.

Updated: September 7, 2025

Lab 6: Use of Inbuilt Functions and Relational Algebra Operations

Objective: To understand the use of inbuilt functions and relational algebra operations with SQL queries using the COMPANY database schema.

Updated: September 22, 2025

Lab 7: SQL Joins and Set Operations

Objective: To understand and implement various types of joins and set operations in SQL queries for combining data from multiple tables.

Updated: October 15, 2025

Lab 8: Use of Different SQL Clauses and JOIN Operations

Objective: To learn how to use different SQL clauses and JOIN operations to retrieve and manipulate data from database tables.

Updated: October 22, 2025

Lab 9: Understanding Database Views

Objective: To understand and implement database views for creating virtual tables based on SQL queries.

Updated: October 29, 2025

Lab 10: Creating SQL Views on COMPANY Database

Objective: To understand and implement database views for creating virtual tables based on SQL queries using the COMPANY database schema.

Updated: November 5, 2025

Lab 11: Understanding and Implementing SQL Indexes

Objective: To understand and implement various types of SQL indexes including basic, unique, composite, and function-based indexes for query optimization.

Updated: November 12, 2025

Lab 12: Understanding and Implementing SQL Sequences

Objective: To understand and implement SQL sequences for generating unique numbers, including creating, modifying, and using sequences in database applications.

Updated: November 19, 2025

Lab 13: Introduction to PL/SQL Programming

Objective: To learn the fundamentals of PL/SQL programming including blocks, variables, control structures, procedures, functions, and cursors for database applications.

Updated: November 26, 2025

AI-Enhanced Database Lab Viva

Complete your database assignment with AI assistance. Design, prompt, solve, and critique database problems using modern AI tools.

Updated: November 24, 2025